CREATE TABLE [dbo].[DnnProduct_SR_SQL_Reports]
(
[ReportID] [int] NOT NULL IDENTITY(1, 1),
[ModuleID] [int] NOT NULL,
[ReportName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ReportDefinition] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ReportHeader] [nvarchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ReportFooter] [nvarchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ConnectionID] [int] NOT NULL CONSTRAINT [DF_SR_SQL_Reports_ConnectionID] DEFAULT ((0)),
[DateCreated] [datetime] NOT NULL CONSTRAINT [DF_SR_SQL_Reports_DateCreated] DEFAULT (getdate()),
[RestrictViewing] [bit] NOT NULL CONSTRAINT [DF_SR_SQL_Reports_RestrictViewing] DEFAULT ((0)),
[HtmlEncode] [bit] NOT NULL CONSTRAINT [DF_SR_SQL_Reports_HtmlEncode] DEFAULT ((1)),
[AutoExecute] [bit] NOT NULL CONSTRAINT [DF_SR_SQL_Reports_AutoExecute] DEFAULT ((0)),
[HideHeader] [bit] NOT NULL CONSTRAINT [DF_SR_SQL_Reports_HideHeader] DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[DnnProduct_SR_SQL_Reports] ADD CONSTRAINT [PK_SR_SQL_Reports] PRIMARY KEY CLUSTERED  ([ReportID]) ON [PRIMARY]
GO
